{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Help","Summary","Transactions","Downloaded info","Report","Data from CSV file"],"not_rendered":{"charts":4,"images":12,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Help","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[13,0,13,3],[24,5,24,6],[17,0,17,3],[17,5,17,9],[30,5,30,6],[25,5,25,6],[26,5,26,6],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1]]}
[]
[null,null,null,null,null,null,null,null,"Account 1:",0]
[null,null,null,null,null,null,null,null,"Account 2:",10]
[null,null,null,null,null,null,null,null,"Cash:",0]
[null,null,null,null,null,null,null,null,"Other: ",0]
[]
[null,null,null,null,null,null,null,null,"Starting balance:",{"$f":"SUM(J2:J5)","v":10}]
[null,null,null,null,null,null,null,null,"Ending Balance:",{"$f":"J7+J11","v":-354.62}]
[]
[]
[null,null,null,null,null,null,null,null,"Net Gain/Loss",{"$f":"G16-B16","v":-364.62}]
[]
[]
["Expenses",null,null,null,null,"Income"]
["Planned",{"$f":"B20","v":300},null,null,null,"Planned",{"$f":"G20","v":400}]
["Actual",{"$f":"C20","v":748.4},{"$f":"SUM(B15-B16)","v":-448.4},null,null,"Actual",{"$f":"H20","v":383.78},{"$f":"SUM(G15-G16)","v":16.220000000000027}]
[]
["Expenses",null,null,null,null,"Income"]
["Categories","Planned","Actual","Difference",null,"Categories","Planned","Actual","Difference"]
["Totals",{"$f":"SUM(B21:B38)","v":300},{"$f":"SUM(C21:C38)","v":748.4},{"$f":"SUM(D21:D38)","v":-448.40000000000003},null,"Totals",{"$f":"SUM(G21:G24)","v":400},{"$f":"SUM(H21:H24)","v":383.78},{"$f":"SUM(I21:I24)","v":-16.220000000000027}]
["Books",0,{"$f":"IF(ISBLANK($A21), \"\", SUMIF(Transactions!$E:$E,$A21,Transactions!$C:$C))","v":26.97},{"$f":"IF(ISBLANK($A21), \"\", B21-C21)","v":-26.97},null,"Interest",0,{"$f":"IF(ISBLANK($F21), \"\", SUMIF(Transactions!$J:$J,$F21,Transactions!$H:$H))","v":0},{"$f":"IF(ISBLANK($F21), \"\", H21-G21)","v":0}]
["Credit Card",100,{"$f":"IF(ISBLANK($A22), \"\", SUMIF(Transactions!$E:$E,$A22,Transactions!$C:$C))","v":92.64},7.3599999999999994,null,"Other",0,{"$f":"IF(ISBLANK($F22), \"\", SUMIF(Transactions!$J:$J,$F22,Transactions!$H:$H))","v":0},{"$f":"IF(ISBLANK($F22), \"\", H22-G22)","v":0}]
["Dates",10,{"$f":"IF(ISBLANK($A23), \"\", SUMIF(Transactions!$E:$E,$A23,Transactions!$C:$C))","v":8.6199999999999992},1.3800000000000008,null,"Paycheck",400,{"$f":"IF(ISBLANK($F23), \"\", SUMIF(Transactions!$J:$J,$F23,Transactions!$H:$H))","v":383.78},{"$f":"IF(ISBLANK($F23), \"\", H23-G23)","v":-16.220000000000027}]
["Fast Offerings",10,{"$f":"IF(ISBLANK($A24), \"\", SUMIF(Transactions!$E:$E,$A24,Transactions!$C:$C))","v":0},10,null,"Savings",0,{"$f":"IF(ISBLANK($F24), \"\", SUMIF(Transactions!$J:$J,$F24,Transactions!$H:$H))","v":0},{"$f":"IF(ISBLANK($F24), \"\", H24-G24)","v":0}]
["Food",40,{"$f":"IF(ISBLANK($A25), \"\", SUMIF(Transactions!$E:$E,$A25,Transactions!$C:$C))","v":119.41000000000001},-79.410000000000011]
["Gifts",0,{"$f":"IF(ISBLANK($A26), \"\", SUMIF(Transactions!$E:$E,$A26,Transactions!$C:$C))","v":0},0]
["Health/Medical",5,{"$f":"IF(ISBLANK($A27), \"\", SUMIF(Transactions!$E:$E,$A27,Transactions!$C:$C))","v":2.54},2.46]
["Laundry",15,{"$f":"IF(ISBLANK($A28), \"\", SUMIF(Transactions!$E:$E,$A28,Transactions!$C:$C))","v":16.5},-1.5]
["Misc",50,{"$f":"IF(ISBLANK($A29), \"\", SUMIF(Transactions!$E:$E,$A29,Transactions!$C:$C))","v":74.150000000000006},-24.150000000000006]
["Pets",0,{"$f":"IF(ISBLANK($A30), \"\", SUMIF(Transactions!$E:$E,$A30,Transactions!$C:$C))","v":0},0]
["Phone",0,{"$f":"IF(ISBLANK($A31), \"\", SUMIF(Transactions!$E:$E,$A31,Transactions!$C:$C))","v":0},0]
["Rent",0,{"$f":"IF(ISBLANK($A32), \"\", SUMIF(Transactions!$E:$E,$A32,Transactions!$C:$C))","v":324.45999999999998},-324.45999999999998]
["Textbooks",0,{"$f":"IF(ISBLANK($A33), \"\", SUMIF(Transactions!$E:$E,$A33,Transactions!$C:$C))","v":0},0]
["Tithing",40,{"$f":"IF(ISBLANK($A34), \"\", SUMIF(Transactions!$E:$E,$A34,Transactions!$C:$C))","v":73.11},-33.11]
["Transportation",30,{"$f":"IF(ISBLANK($A35), \"\", SUMIF(Transactions!$E:$E,$A35,Transactions!$C:$C))","v":10},20]
["Travel",0,{"$f":"IF(ISBLANK($A36), \"\", SUMIF(Transactions!$E:$E,$A36,Transactions!$C:$C))","v":0},0]
["Tuition",0,{"$f":"IF(ISBLANK($A37), \"\", SUMIF(Transactions!$E:$E,$A37,Transactions!$C:$C))","v":0},0]
["Utilities",0,{"$f":"IF(ISBLANK($A38), \"\", SUMIF(Transactions!$E:$E,$A38,Transactions!$C:$C))","v":0},0]

{"sheet":"Transactions","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[null,"Expenses",null,null,null,null,"Income"]
[]
[null,"Date","Amount","Description","Category",null,"Date","Amount","Description","Category"]
[null,"2016-11-01",24.73,"LDS CHURCH       DONATION   13216105        WEB ID: 2870834341","Tithing",null,"2016-11-10",143.85,"BRIGHAM YOUNG UN DIR DEP                    PPD ID: 1870217280","Paycheck"]
[null,"2016-11-02",7.3,"ZURCHERS SITE 117 OREM OREM UT               10/31","Misc",null,"2016-11-25",239.93,"BRIGHAM YOUNG UN DIR DEP                    PPD ID: 1870217280","Paycheck"]
[null,"2016-11-07",92.64,"CAPITAL ONE      ONLINE PMT 630939919257000 WEB ID: 9279744991","Credit Card"]
[null,"2016-11-07",28.73,"SMITHS    350 N. FREED PROVO UT              11/05","Food"]
[null,"2016-11-07",6.85,"USPS KIOSK 49717 95 W PROVO UT       944508  11/05","Misc"]
[null,"2016-11-07",5.5,"CHANGE POINT LAUNDRY LITHIA SPRING GA        11/05","Laundry"]
[null,"2016-11-07",8.99,"Amazon Services-Kindl 866-321-8851 WA        11/05","Books"]
[null,"2016-11-14",5,"BYU              eCheck     348175935       WEB ID: 9870217280","Food"]
[null,"2016-11-15",8.99,"Amazon Services-Kindl 866-321-8851 WA        11/14","Books"]
[null,"2016-11-16",60,"BYU              eCheck     348175935       WEB ID: 9870217280","Misc"]
[null,"2016-11-16",5.5,"CHANGE POINT LAUNDRY LITHIA SPRING GA        11/15","Laundry"]
[null,"2016-11-21",24.39,"LDS CHURCH       DONATION   13804165        WEB ID: 2870834341","Tithing"]
[null,"2016-11-22",2.54,"WM SUPERC Wal-Mart Sup OREM UT               11/22","Health/Medical"]
[null,"2016-11-22",30.87,"Wal-Mart Super Center OREM UT                11/22","Food"]
[null,"2016-11-22",8.99,"Amazon Services-Kindl 866-321-8851 WA        11/22","Books"]
[null,"2016-11-22",8.6199999999999992,"CAFE RIO PROVO PROVO UT                      11/21","Dates"]
[null,"2016-11-25",5.5,"CHANGE POINT LAUNDRY LITHIA SPRING GA        11/22","Laundry"]
[null,"2016-11-28",10,"VENMO            PAYMENT    346609175       WEB ID: 3264681992","Transportation"]
[null,"2016-11-29",54.81,"SMITHS    350 N. FREED PROVO UT              11/29","Food"]
[null,"2016-11-30",23.99,"LDS CHURCH       DONATION   14061715        WEB ID: 2870834341","Tithing"]
[null,"2016-11-30",324.45999999999998,"P.A.R. Managemen WEB PMTS   V7CJG3          WEB ID: 9000334713","Rent"]

{"sheet":"Downloaded info","index":3,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Path:","J:\\groups\\ce270project\\Chase Data.CSV"]
[null,"Name:","Chase Data"]
[]
["Details","Posting Date","Description","Amount","Balance","Check or Slip #"]
["DEBIT","2016-11-01","LDS CHURCH       DONATION   13216105        WEB ID: 2870834341",-24.73,1507.39]
["DEBIT","2016-11-02","ZURCHERS SITE 117 OREM OREM UT               10/31",-7.3,1500.09]
["DEBIT","2016-11-07","CAPITAL ONE      ONLINE PMT 630939919257000 WEB ID: 9279744991",-92.64,1357.38]
["DEBIT","2016-11-07","SMITHS    350 N. FREED PROVO UT              11/05",-28.73,1450.02]
["DEBIT","2016-11-07","USPS KIOSK 49717 95 W PROVO UT       944508  11/05",-6.85,1478.75]
["DEBIT","2016-11-07","CHANGE POINT LAUNDRY LITHIA SPRING GA        11/05",-5.5,1485.6]
["DEBIT","2016-11-07","Amazon Services-Kindl 866-321-8851 WA        11/05",-8.99,1491.1]
["CREDIT","2016-11-10","BRIGHAM YOUNG UN DIR DEP                    PPD ID: 1870217280",143.85,1501.23]
["DEBIT","2016-11-14","BYU              eCheck     348175935       WEB ID: 9870217280",-5,1496.23]
["DEBIT","2016-11-15","Amazon Services-Kindl 866-321-8851 WA        11/14",-8.99,1487.24]
["DEBIT","2016-11-16","BYU              eCheck     348175935       WEB ID: 9870217280",-60,1421.74]
["DEBIT","2016-11-16","CHANGE POINT LAUNDRY LITHIA SPRING GA        11/15",-5.5,1481.74]
["DEBIT","2016-11-21","LDS CHURCH       DONATION   13804165        WEB ID: 2870834341",-24.39,1397.35]
["DEBIT","2016-11-22","WM SUPERC Wal-Mart Sup OREM UT               11/22",-2.54,1346.33]
["DEBIT","2016-11-22","Wal-Mart Super Center OREM UT                11/22",-30.87,1348.87]
["DEBIT","2016-11-22","Amazon Services-Kindl 866-321-8851 WA        11/22",-8.99,1379.74]
["DEBIT","2016-11-22","CAFE RIO PROVO PROVO UT                      11/21",-8.6199999999999992,1388.73]
["DEBIT","2016-11-25","CHANGE POINT LAUNDRY LITHIA SPRING GA        11/22",-5.5,1580.76]
["CREDIT","2016-11-25","BRIGHAM YOUNG UN DIR DEP                    PPD ID: 1870217280",239.93,1586.26]
["DEBIT","2016-11-28","VENMO            PAYMENT    346609175       WEB ID: 3264681992",-10,1570.76]
["DEBIT","2016-11-29","SMITHS    350 N. FREED PROVO UT              11/29",-54.81,1515.95]
["DEBIT","2016-11-30","LDS CHURCH       DONATION   14061715        WEB ID: 2870834341",-23.99,1167.5]
["DEBIT","2016-11-30","P.A.R. Managemen WEB PMTS   V7CJG3          WEB ID: 9000334713",-324.45999999999998,1191.49]

{"sheet":"Report","index":4,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,4,0,6]]}
["Financial Report-",null,null,null,"2016-12-08"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Categories","Planned","Actual","Difference",null,"Categories","Planned","Actual","Difference"]
[null,"Totals",300,748.4,-448.4,null,"Totals",400,383.78,-16.22]
[null,"Books",0,0,0,null,"Interest",0,0,0]
[null,"Credit Card",100,0,100,null,"Other",0,0,0]
[null,"Dates",10,0,10,null,"Paycheck",400,383.78,-16.22]
[null,"Fast Offerings",10,0,10,null,"Savings",0,0,0]
[null,"Food",40,748.4,-708.4]
[null,"Gifts",0,0,0]
[null,"Health/Medical",5,0,5]
[null,"Laundry",15,0,15]
[null,"Misc",50,0,50,null,"Net Gain/Loss",-364.62]
[null,"Pets",0,0,0]
[null,"Phone",0,0,0,null,"Starting balance:",10]
[null,"Rent",0,0,0,null,"Ending Balance:",-354.62]
[null,"Textbooks",0,0,0]
[null,"Tithing",40,0,40]
[null,"Transportation",30,0,30]
[null,"Travel",0,0,0]
[null,"Tuition",0,0,0]
[null,"Utilities",0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"q"]

{"sheet":"Data from CSV file","index":5,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Details","Posting Date","Description","Amount","Type","Balance","Check or Slip #"]
["DEBIT","2016-11-30","Tithing",-20,"ACH_DEBIT"]
["DEBIT","2016-11-30","Rent and Utilities",-320,"ACH_DEBIT"]
["DEBIT","2016-11-29","Food",-60,"DEBIT_CARD"]
["DEBIT","2016-11-28","Gas",-10,"ACH_DEBIT"]
["DEBIT","2016-11-25","Laundry",-5.5,"DEBIT_CARD"]
["CREDIT","2016-11-25","Paycheck",300,"ACH_CREDIT"]
["DEBIT","2016-11-22","Medicine",-3,"DEBIT_CARD"]
["DEBIT","2016-11-22","Food",-30,"DEBIT_CARD"]
["DEBIT","2016-11-22","Books",-9,"DEBIT_CARD"]
["DEBIT","2016-11-22","Café Rio",-9,"DEBIT_CARD"]
["DEBIT","2016-11-21","Tithing",-30,"ACH_DEBIT"]
["DEBIT","2016-11-16","Dance Lessons",-60,"ACH_DEBIT"]
["DEBIT","2016-11-16","Laundry",-5.5,"DEBIT_CARD"]
["DEBIT","2016-11-15","Books",-9,"DEBIT_CARD"]
["DEBIT","2016-11-14","Food",-5,"ACH_DEBIT"]
["CREDIT","2016-11-10","Paycheck",200,"ACH_CREDIT"]
["DEBIT","2016-11-07","Credit Card",-100,"ACH_DEBIT"]
["DEBIT","2016-11-07","Food",-30,"DEBIT_CARD"]
["DEBIT","2016-11-07","Mail Stamps",-10,"DEBIT_CARD"]
["DEBIT","2016-11-07","Laundry",-5.5,"DEBIT_CARD"]
["DEBIT","2016-11-07","Books",-9,"DEBIT_CARD"]
["DEBIT","2016-11-02","Halloween Costume",-8,"DEBIT_CARD"]
["DEBIT","2016-11-01","Tithing",-30,"ACH_DEBIT"]